TO_CHAR (number)
Purpose
This function converts a number into a string.
Syntax
to_char (number)::=
Usage Notes
For information about supported numeric formats, see Numeric format models.
Example
SELECT TO_CHAR(12345.6789) TO_CHAR;
SELECT TO_CHAR(12345.67890, '9999999.999999999') TO_CHAR;
SELECT TO_CHAR(-12345.67890, '000G000G000D000000MI') TO_CHAR;